/*
 * The contents of this file are subject to the Mozilla Public License
 * Version 1.1 (the "License"); you may not use this file except in
 * compliance with the License. You may obtain a copy of the License at
 * http://www.mozilla.org/MPL/
 *
 * Software distributed under the License is distributed on an "AS IS"
 * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
 * License for the specific language governing rights and limitations
 * under the License.
 * 
 * The Original Code is iSQL-Viewer, A Mutli-Platform Database Tool.
 *
 * The Initial Developer of the Original Code is iSQL-Viewer, A Mutli-Platform Database Tool.
 * Portions created by Mark A. Kobold are Copyright (C) 2000-2007. All Rights Reserved.
 *
 * Contributor(s): 
 *  Mark A. Kobold [mkobold <at> isqlviewer <dot> com].
 *  
 * If you didn't download this code from the following link, you should check
 * if you aren't using an obsolete version: http://www.isqlviewer.com
 */
package org.isqlviewer.sql.platform;

import java.net.InetAddress;
import java.net.UnknownHostException;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;

import org.isqlviewer.sql.PlatformRegistrar;
import org.isqlviewer.util.IsqlToolkit;
import org.isqlviewer.util.LoggableObject;

/**
 * Oracle Session registration code.
 * <p>
 * makes a call to DBMS_APPLICATION_INFO.SET_CLIENT_INFO(?) identifying the session as an iSQL-Viewer session to the
 * database server, and any DBA's looking into V$SESSION or whatever that table is.
 * 
 * @author Mark A. Kobold &lt;mkobold at isqlviewer dot com&gt;
 * @version 1.0
 */
public class OracleRegistrar extends LoggableObject implements PlatformRegistrar {

    public boolean register(Connection nativeConnection) throws SQLException {

        CallableStatement insertEvent = null;
        String hostname = null;
        try {
            hostname = InetAddress.getLocalHost().toString();
        } catch (UnknownHostException uhe) {
            hostname = "localhost/unknown";
        }

        String appid = "iSQL-Viewer/" + IsqlToolkit.getVersionInfo() + "@" + hostname;
        try {
            insertEvent = nativeConnection.prepareCall("{ call dbms_application_info.set_client_info(?) }");
            insertEvent.setString(1, appid);
            insertEvent.execute();
            return true;
        } finally {
            if (insertEvent != null) {
                try {
                    insertEvent.close();
                } catch (SQLException sqle) {
                }
            }
        }

    }

}
